﻿<?xml version="1.0" encoding="utf-8" ?> 
<sprocs>
  <sproc name="GetPeople">
    <sql>
      CREATE PROCEDURE {0}.GetPeople AS SELECT p.id, p.visible, p.firstName, p.middleName, p.lastName, p.title, p.description, p.email, p.phone, p.fax, p.streetAddress, p.city, p.state, p.postalCode, p.country, p.imageUrl, p.imageAltText FROM People p
    </sql>
  </sproc>
</sprocs>
